using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace CommerceForUmbraco.xsltExtensions{
    public partial class SPs{
        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetAllSubs Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetAllSubs(int? parentID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetAllSubs" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@parentID", parentID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAdministration_GetCountOfState Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAdministrationGetCountOfState(int? Count, bool? AllUsersScope, string ApplicationName, string Path, string UserName, DateTime? InactiveSinceDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAdministration_GetCountOfState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddOutputParameter("@Count",DbType.Int32);
        	    
            sp.Command.AddParameter("@AllUsersScope", AllUsersScope,DbType.Boolean);
        	    
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@InactiveSinceDate", InactiveSinceDate,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetByProductID Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetByProductID(int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetByProductID" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAdministration_ResetSharedState Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAdministrationResetSharedState(int? Count, string ApplicationName, string Path)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAdministration_ResetSharedState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddOutputParameter("@Count",DbType.Int32);
        	    
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetCrumbs Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetCrumbs(int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetCrumbs" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAdministration_ResetUserState Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAdministrationResetUserState(int? Count, string ApplicationName, DateTime? InactiveSinceDate, string UserName, string Path)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAdministration_ResetUserState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddOutputParameter("@Count",DbType.Int32);
        	    
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@InactiveSinceDate", InactiveSinceDate,DbType.DateTime);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetPageByGUIDMulti Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetPageByGUIDMulti(string categoryGUID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetPageByGUIDMulti" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryGUID", categoryGUID,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAllUsers_GetPageSettings Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAllUsersGetPageSettings(string ApplicationName, string Path)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAllUsers_GetPageSettings" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetPageByNameMulti Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetPageByNameMulti(string categoryName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetPageByNameMulti" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryName", categoryName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAllUsers_ResetPageSettings Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAllUsersResetPageSettings(string ApplicationName, string Path)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAllUsers_ResetPageSettings" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetPageMulti Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetPageMulti(int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetPageMulti" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAllUsers_SetPageSettings Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAllUsersSetPageSettings(string ApplicationName, string Path, byte[] PageSettings, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAllUsers_SetPageSettings" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddParameter("@PageSettings", PageSettings,DbType.Binary);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Config_GetList Procedure
        /// </summary>
        public static StoredProcedure CskStoreConfigGetList()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Config_GetList" , DataService.GetInstance("XsltExt"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationPerUser_GetPageSettings Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationPerUserGetPageSettings(string ApplicationName, string UserName, string Path, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationPerUser_GetPageSettings" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Order_Query Procedure
        /// </summary>
        public static StoredProcedure CskStoreOrderQuery(DateTime? dateStart, DateTime? dateEnd, string userName, string orderNumber)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Order_Query" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@dateStart", dateStart,DbType.DateTime);
        	    
            sp.Command.AddParameter("@dateEnd", dateEnd,DbType.DateTime);
        	    
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            sp.Command.AddParameter("@orderNumber", orderNumber,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationPerUser_ResetPageSettings Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationPerUserResetPageSettings(string ApplicationName, string UserName, string Path, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationPerUser_ResetPageSettings" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_AddRating Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductAddRating(int? productID, int? rating, string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_AddRating" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            sp.Command.AddParameter("@rating", rating,DbType.Int32);
        	    
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationPerUser_SetPageSettings Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationPerUserSetPageSettings(string ApplicationName, string UserName, string Path, byte[] PageSettings, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationPerUser_SetPageSettings" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddParameter("@PageSettings", PageSettings,DbType.Binary);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_DeletePermanent Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductDeletePermanent(int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_DeletePermanent" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Personalization_GetApplicationId Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationGetApplicationId(string ApplicationName, Guid? ApplicationId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Personalization_GetApplicationId" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddOutputParameter("@ApplicationId",DbType.Guid);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByCategoryID Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductGetByCategoryID(int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByCategoryID" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Profile_DeleteInactiveProfiles Procedure
        /// </summary>
        public static StoredProcedure AspnetProfileDeleteInactiveProfiles(string ApplicationName, int? ProfileAuthOptions, DateTime? InactiveSinceDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Profile_DeleteInactiveProfiles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@ProfileAuthOptions", ProfileAuthOptions,DbType.Int32);
        	    
            sp.Command.AddParameter("@InactiveSinceDate", InactiveSinceDate,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByCategoryName Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductGetByCategoryName(string categoryName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByCategoryName" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryName", categoryName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Profile_DeleteProfiles Procedure
        /// </summary>
        public static StoredProcedure AspnetProfileDeleteProfiles(string ApplicationName, string UserNames)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Profile_DeleteProfiles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserNames", UserNames,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByManufacturerID Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductGetByManufacturerID(int? manufacturerID, int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByManufacturerID" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@manufacturerID", manufacturerID,DbType.Int32);
        	    
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Profile_GetNumberOfInactiveProfiles Procedure
        /// </summary>
        public static StoredProcedure AspnetProfileGetNumberOfInactiveProfiles(string ApplicationName, int? ProfileAuthOptions, DateTime? InactiveSinceDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Profile_GetNumberOfInactiveProfiles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@ProfileAuthOptions", ProfileAuthOptions,DbType.Int32);
        	    
            sp.Command.AddParameter("@InactiveSinceDate", InactiveSinceDate,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByPriceRange Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductGetByPriceRange(int? categoryID, decimal? priceStart, decimal? priceEnd)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByPriceRange" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	    
            sp.Command.AddParameter("@priceStart", priceStart,DbType.Currency);
        	    
            sp.Command.AddParameter("@priceEnd", priceEnd,DbType.Currency);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Profile_GetProfiles Procedure
        /// </summary>
        public static StoredProcedure AspnetProfileGetProfiles(string ApplicationName, int? ProfileAuthOptions, int? PageIndex, int? PageSize, string UserNameToMatch, DateTime? InactiveSinceDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Profile_GetProfiles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@ProfileAuthOptions", ProfileAuthOptions,DbType.Int32);
        	    
            sp.Command.AddParameter("@PageIndex", PageIndex,DbType.Int32);
        	    
            sp.Command.AddParameter("@PageSize", PageSize,DbType.Int32);
        	    
            sp.Command.AddParameter("@UserNameToMatch", UserNameToMatch,DbType.String);
        	    
            sp.Command.AddParameter("@InactiveSinceDate", InactiveSinceDate,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetMostPopular Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductGetMostPopular()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetMostPopular" , DataService.GetInstance("XsltExt"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Profile_GetProperties Procedure
        /// </summary>
        public static StoredProcedure AspnetProfileGetProperties(string ApplicationName, string UserName, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Profile_GetProperties" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetPostAddMulti Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductGetPostAddMulti(string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetPostAddMulti" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Profile_SetProperties Procedure
        /// </summary>
        public static StoredProcedure AspnetProfileSetProperties(string ApplicationName, string PropertyNames, string PropertyValuesString, byte[] PropertyValuesBinary, string UserName, bool? IsUserAnonymous, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Profile_SetProperties" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@PropertyNames", PropertyNames,DbType.String);
        	    
            sp.Command.AddParameter("@PropertyValuesString", PropertyValuesString,DbType.String);
        	    
            sp.Command.AddParameter("@PropertyValuesBinary", PropertyValuesBinary,DbType.Binary);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@IsUserAnonymous", IsUserAnonymous,DbType.Boolean);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_SmartSearch Procedure
        /// </summary>
        public static StoredProcedure CskStoreProductSmartSearch(int? DescriptionLength, bool? AllWords, string Word1, string Word2, string Word3, string Word4, string Word5)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_SmartSearch" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@DescriptionLength", DescriptionLength,DbType.Int32);
        	    
            sp.Command.AddParameter("@AllWords", AllWords,DbType.Boolean);
        	    
            sp.Command.AddParameter("@Word1", Word1,DbType.String);
        	    
            sp.Command.AddParameter("@Word2", Word2,DbType.String);
        	    
            sp.Command.AddParameter("@Word3", Word3,DbType.String);
        	    
            sp.Command.AddParameter("@Word4", Word4,DbType.String);
        	    
            sp.Command.AddParameter("@Word5", Word5,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_RegisterSchemaVersion Procedure
        /// </summary>
        public static StoredProcedure AspnetRegisterSchemaVersion(string Feature, string CompatibleSchemaVersion, bool? IsCurrentVersion, bool? RemoveIncompatibleSchema)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_RegisterSchemaVersion" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@Feature", Feature,DbType.String);
        	    
            sp.Command.AddParameter("@CompatibleSchemaVersion", CompatibleSchemaVersion,DbType.String);
        	    
            sp.Command.AddParameter("@IsCurrentVersion", IsCurrentVersion,DbType.Boolean);
        	    
            sp.Command.AddParameter("@RemoveIncompatibleSchema", RemoveIncompatibleSchema,DbType.Boolean);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_CalculateAmountByState Procedure
        /// </summary>
        public static StoredProcedure CskTaxCalculateAmountByState(string stateAbbreviation, decimal? subTotal)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_CalculateAmountByState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@stateAbbreviation", stateAbbreviation,DbType.String);
        	    
            sp.Command.AddParameter("@subTotal", subTotal,DbType.Currency);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Roles_CreateRole Procedure
        /// </summary>
        public static StoredProcedure AspnetRolesCreateRole(string ApplicationName, string RoleName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Roles_CreateRole" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_CalculateAmountByZIP Procedure
        /// </summary>
        public static StoredProcedure CskTaxCalculateAmountByZIP(string zipCode, decimal? subTotal)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_CalculateAmountByZIP" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@zipCode", zipCode,DbType.String);
        	    
            sp.Command.AddParameter("@subTotal", subTotal,DbType.Currency);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Roles_DeleteRole Procedure
        /// </summary>
        public static StoredProcedure AspnetRolesDeleteRole(string ApplicationName, string RoleName, bool? DeleteOnlyIfRoleIsEmpty)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Roles_DeleteRole" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            sp.Command.AddParameter("@DeleteOnlyIfRoleIsEmpty", DeleteOnlyIfRoleIsEmpty,DbType.Boolean);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_GetTaxRate Procedure
        /// </summary>
        public static StoredProcedure CskTaxGetTaxRate(string zip)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_GetTaxRate" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@zip", zip,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Roles_GetAllRoles Procedure
        /// </summary>
        public static StoredProcedure AspnetRolesGetAllRoles(string ApplicationName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Roles_GetAllRoles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_SaveZipRate Procedure
        /// </summary>
        public static StoredProcedure CskTaxSaveZipRate(string state, string zipCode, decimal? rate, string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_SaveZipRate" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@state", state,DbType.String);
        	    
            sp.Command.AddParameter("@zipCode", zipCode,DbType.String);
        	    
            sp.Command.AddParameter("@rate", rate,DbType.Currency);
        	    
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Roles_RoleExists Procedure
        /// </summary>
        public static StoredProcedure AspnetRolesRoleExists(string ApplicationName, string RoleName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Roles_RoleExists" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the ClearLogs Procedure
        /// </summary>
        public static StoredProcedure ClearLogs()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("ClearLogs" , DataService.GetInstance("XsltExt"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Setup_RemoveAllRoleMembers Procedure
        /// </summary>
        public static StoredProcedure AspnetSetupRemoveAllRoleMembers(string name)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Setup_RemoveAllRoleMembers" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@name", name,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the InsertCategoryLog Procedure
        /// </summary>
        public static StoredProcedure InsertCategoryLog(int? CategoryID, int? LogID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("InsertCategoryLog" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@CategoryID", CategoryID,DbType.Int32);
        	    
            sp.Command.AddParameter("@LogID", LogID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Setup_RestorePermissions Procedure
        /// </summary>
        public static StoredProcedure AspnetSetupRestorePermissions(string name)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Setup_RestorePermissions" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@name", name,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the WriteLog Procedure
        /// </summary>
        public static StoredProcedure WriteLog(int? EventID, int? Priority, string Severity, string Title, DateTime? Timestamp, string MachineName, string AppDomainName, string ProcessID, string ProcessName, string ThreadName, string Win32ThreadId, string Message, string FormattedMessage, int? LogId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("WriteLog" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@EventID", EventID,DbType.Int32);
        	    
            sp.Command.AddParameter("@Priority", Priority,DbType.Int32);
        	    
            sp.Command.AddParameter("@Severity", Severity,DbType.String);
        	    
            sp.Command.AddParameter("@Title", Title,DbType.String);
        	    
            sp.Command.AddParameter("@Timestamp", Timestamp,DbType.DateTime);
        	    
            sp.Command.AddParameter("@MachineName", MachineName,DbType.String);
        	    
            sp.Command.AddParameter("@AppDomainName", AppDomainName,DbType.String);
        	    
            sp.Command.AddParameter("@ProcessID", ProcessID,DbType.String);
        	    
            sp.Command.AddParameter("@ProcessName", ProcessName,DbType.String);
        	    
            sp.Command.AddParameter("@ThreadName", ThreadName,DbType.String);
        	    
            sp.Command.AddParameter("@Win32ThreadId", Win32ThreadId,DbType.String);
        	    
            sp.Command.AddParameter("@Message", Message,DbType.String);
        	    
            sp.Command.AddParameter("@FormattedMessage", FormattedMessage,DbType.String);
        	    
            sp.Command.AddOutputParameter("@LogId",DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UnRegisterSchemaVersion Procedure
        /// </summary>
        public static StoredProcedure AspnetUnRegisterSchemaVersion(string Feature, string CompatibleSchemaVersion)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UnRegisterSchemaVersion" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@Feature", Feature,DbType.String);
        	    
            sp.Command.AddParameter("@CompatibleSchemaVersion", CompatibleSchemaVersion,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UsersInRoles_AddUsersToRoles Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersInRolesAddUsersToRoles(string ApplicationName, string UserNames, string RoleNames, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UsersInRoles_AddUsersToRoles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserNames", UserNames,DbType.String);
        	    
            sp.Command.AddParameter("@RoleNames", RoleNames,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UsersInRoles_FindUsersInRole Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersInRolesFindUsersInRole(string ApplicationName, string RoleName, string UserNameToMatch)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UsersInRoles_FindUsersInRole" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            sp.Command.AddParameter("@UserNameToMatch", UserNameToMatch,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UsersInRoles_GetRolesForUser Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersInRolesGetRolesForUser(string ApplicationName, string UserName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UsersInRoles_GetRolesForUser" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UsersInRoles_GetUsersInRoles Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersInRolesGetUsersInRoles(string ApplicationName, string RoleName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UsersInRoles_GetUsersInRoles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UsersInRoles_IsUserInRole Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersInRolesIsUserInRole(string ApplicationName, string UserName, string RoleName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UsersInRoles_IsUserInRole" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@RoleName", RoleName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_UsersInRoles_RemoveUsersFromRoles Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersInRolesRemoveUsersFromRoles(string ApplicationName, string UserNames, string RoleNames)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_UsersInRoles_RemoveUsersFromRoles" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserNames", UserNames,DbType.String);
        	    
            sp.Command.AddParameter("@RoleNames", RoleNames,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Users_CreateUser Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersCreateUser(Guid? ApplicationId, string UserName, bool? IsUserAnonymous, DateTime? LastActivityDate, Guid? UserId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Users_CreateUser" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationId", ApplicationId,DbType.Guid);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@IsUserAnonymous", IsUserAnonymous,DbType.Boolean);
        	    
            sp.Command.AddParameter("@LastActivityDate", LastActivityDate,DbType.DateTime);
        	    
            sp.Command.AddOutputParameter("@UserId",DbType.Guid);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Users_DeleteUser Procedure
        /// </summary>
        public static StoredProcedure AspnetUsersDeleteUser(string ApplicationName, string UserName, int? TablesToDeleteFrom, int? NumTablesDeletedFrom)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Users_DeleteUser" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@TablesToDeleteFrom", TablesToDeleteFrom,DbType.Int32);
        	    
            sp.Command.AddOutputParameter("@NumTablesDeletedFrom",DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_WebEvent_LogEvent Procedure
        /// </summary>
        public static StoredProcedure AspnetWebEventLogEvent(string EventId, DateTime? EventTimeUtc, DateTime? EventTime, string EventType, decimal? EventSequence, decimal? EventOccurrence, int? EventCode, int? EventDetailCode, string Message, string ApplicationPath, string ApplicationVirtualPath, string MachineName, string RequestUrl, string ExceptionType, string Details)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_WebEvent_LogEvent" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@EventId", EventId,DbType.AnsiStringFixedLength);
        	    
            sp.Command.AddParameter("@EventTimeUtc", EventTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@EventTime", EventTime,DbType.DateTime);
        	    
            sp.Command.AddParameter("@EventType", EventType,DbType.String);
        	    
            sp.Command.AddParameter("@EventSequence", EventSequence,DbType.Decimal);
        	    
            sp.Command.AddParameter("@EventOccurrence", EventOccurrence,DbType.Decimal);
        	    
            sp.Command.AddParameter("@EventCode", EventCode,DbType.Int32);
        	    
            sp.Command.AddParameter("@EventDetailCode", EventDetailCode,DbType.Int32);
        	    
            sp.Command.AddParameter("@Message", Message,DbType.String);
        	    
            sp.Command.AddParameter("@ApplicationPath", ApplicationPath,DbType.String);
        	    
            sp.Command.AddParameter("@ApplicationVirtualPath", ApplicationVirtualPath,DbType.String);
        	    
            sp.Command.AddParameter("@MachineName", MachineName,DbType.String);
        	    
            sp.Command.AddParameter("@RequestUrl", RequestUrl,DbType.String);
        	    
            sp.Command.AddParameter("@ExceptionType", ExceptionType,DbType.String);
        	    
            sp.Command.AddParameter("@Details", Details,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the INSERT_CSK_Store_OfflineCC Procedure
        /// </summary>
        public static StoredProcedure InsertCskStoreOfflineCC(int? orderID, string cc, string ccv, int? expMonth, int? expYear, string ccSalt)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("INSERT_CSK_Store_OfflineCC" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@orderID", orderID,DbType.Int32);
        	    
            sp.Command.AddParameter("@cc", cc,DbType.String);
        	    
            sp.Command.AddParameter("@ccv", ccv,DbType.String);
        	    
            sp.Command.AddParameter("@expMonth", expMonth,DbType.Int32);
        	    
            sp.Command.AddParameter("@expYear", expYear,DbType.Int32);
        	    
            sp.Command.AddParameter("@ccSalt", ccSalt,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_IsFreightTaxed Procedure
        /// </summary>
        public static StoredProcedure CskTaxIsFreightTaxed(string zip)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_IsFreightTaxed" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@zip", zip,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the AddCategory Procedure
        /// </summary>
        public static StoredProcedure AddCategory(string CategoryName, int? LogID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("AddCategory" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@CategoryName", CategoryName,DbType.String);
        	    
            sp.Command.AddParameter("@LogID", LogID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Content_Get Procedure
        /// </summary>
        public static StoredProcedure CskContentGet(string contentName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Content_Get" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@contentName", contentName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Content_Insert Procedure
        /// </summary>
        public static StoredProcedure CskContentInsert(Guid? contentGUID, string title, string contentName, string content, string iconPath, DateTime? dateExpires, int? contentGroupID, string lastEditedBy, string externalLink, string status, int? listOrder, string callOut, DateTime? createdOn, string createdBy, DateTime? modifiedOn, string modifiedBy)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Content_Insert" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@contentGUID", contentGUID,DbType.Guid);
        	    
            sp.Command.AddParameter("@title", title,DbType.String);
        	    
            sp.Command.AddParameter("@contentName", contentName,DbType.String);
        	    
            sp.Command.AddParameter("@content", content,DbType.String);
        	    
            sp.Command.AddParameter("@iconPath", iconPath,DbType.String);
        	    
            sp.Command.AddParameter("@dateExpires", dateExpires,DbType.DateTime);
        	    
            sp.Command.AddParameter("@contentGroupID", contentGroupID,DbType.Int32);
        	    
            sp.Command.AddParameter("@lastEditedBy", lastEditedBy,DbType.String);
        	    
            sp.Command.AddParameter("@externalLink", externalLink,DbType.String);
        	    
            sp.Command.AddParameter("@status", status,DbType.String);
        	    
            sp.Command.AddParameter("@listOrder", listOrder,DbType.Int32);
        	    
            sp.Command.AddParameter("@callOut", callOut,DbType.String);
        	    
            sp.Command.AddParameter("@createdOn", createdOn,DbType.DateTime);
        	    
            sp.Command.AddParameter("@createdBy", createdBy,DbType.String);
        	    
            sp.Command.AddParameter("@modifiedOn", modifiedOn,DbType.DateTime);
        	    
            sp.Command.AddParameter("@modifiedBy", modifiedBy,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Content_Save Procedure
        /// </summary>
        public static StoredProcedure CskContentSave(string contentName, string title, string content, int? groupID, string iconPath, string status, string userName, string callOut, string externalLink)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Content_Save" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@contentName", contentName,DbType.String);
        	    
            sp.Command.AddParameter("@title", title,DbType.String);
        	    
            sp.Command.AddParameter("@content", content,DbType.String);
        	    
            sp.Command.AddParameter("@groupID", groupID,DbType.Int32);
        	    
            sp.Command.AddParameter("@iconPath", iconPath,DbType.String);
        	    
            sp.Command.AddParameter("@status", status,DbType.String);
        	    
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            sp.Command.AddParameter("@callOut", callOut,DbType.String);
        	    
            sp.Command.AddParameter("@externalLink", externalLink,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Content_Update Procedure
        /// </summary>
        public static StoredProcedure CskContentUpdate(int? contentID, Guid? contentGUID, string title, string contentName, string content, string iconPath, DateTime? dateExpires, int? contentGroupID, string lastEditedBy, string externalLink, string status, int? listOrder, string callOut, DateTime? createdOn, string createdBy, DateTime? modifiedOn, string modifiedBy)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Content_Update" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@contentID", contentID,DbType.Int32);
        	    
            sp.Command.AddParameter("@contentGUID", contentGUID,DbType.Guid);
        	    
            sp.Command.AddParameter("@title", title,DbType.String);
        	    
            sp.Command.AddParameter("@contentName", contentName,DbType.String);
        	    
            sp.Command.AddParameter("@content", content,DbType.String);
        	    
            sp.Command.AddParameter("@iconPath", iconPath,DbType.String);
        	    
            sp.Command.AddParameter("@dateExpires", dateExpires,DbType.DateTime);
        	    
            sp.Command.AddParameter("@contentGroupID", contentGroupID,DbType.Int32);
        	    
            sp.Command.AddParameter("@lastEditedBy", lastEditedBy,DbType.String);
        	    
            sp.Command.AddParameter("@externalLink", externalLink,DbType.String);
        	    
            sp.Command.AddParameter("@status", status,DbType.String);
        	    
            sp.Command.AddParameter("@listOrder", listOrder,DbType.Int32);
        	    
            sp.Command.AddParameter("@callOut", callOut,DbType.String);
        	    
            sp.Command.AddParameter("@createdOn", createdOn,DbType.DateTime);
        	    
            sp.Command.AddParameter("@createdBy", createdBy,DbType.String);
        	    
            sp.Command.AddParameter("@modifiedOn", modifiedOn,DbType.DateTime);
        	    
            sp.Command.AddParameter("@modifiedBy", modifiedBy,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_GetAllCouponTypes Procedure
        /// </summary>
        public static StoredProcedure CskCouponsGetAllCouponTypes()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_GetAllCouponTypes" , DataService.GetInstance("XsltExt"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_GetCoupon Procedure
        /// </summary>
        public static StoredProcedure CskCouponsGetCoupon(string couponCode)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_GetCoupon" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@couponCode", couponCode,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_GetCouponType Procedure
        /// </summary>
        public static StoredProcedure CskCouponsGetCouponType(int? couponTypeId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_GetCouponType" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@couponTypeId", couponTypeId,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_AnyDataInTables Procedure
        /// </summary>
        public static StoredProcedure AspnetAnyDataInTables(int? TablesToCheck)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_AnyDataInTables" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@TablesToCheck", TablesToCheck,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_SaveCoupon Procedure
        /// </summary>
        public static StoredProcedure CskCouponsSaveCoupon(string CouponCode, int? CouponTypeId, bool? IsSingleUse, int? NumberUses, DateTime? ExpirationDate, string XmlData)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_SaveCoupon" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@CouponCode", CouponCode,DbType.String);
        	    
            sp.Command.AddParameter("@CouponTypeId", CouponTypeId,DbType.Int32);
        	    
            sp.Command.AddParameter("@IsSingleUse", IsSingleUse,DbType.Boolean);
        	    
            sp.Command.AddParameter("@NumberUses", NumberUses,DbType.Int32);
        	    
            sp.Command.AddParameter("@ExpirationDate", ExpirationDate,DbType.DateTime);
        	    
            sp.Command.AddParameter("@XmlData", XmlData,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Applications_CreateApplication Procedure
        /// </summary>
        public static StoredProcedure AspnetApplicationsCreateApplication(string ApplicationName, Guid? ApplicationId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Applications_CreateApplication" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddOutputParameter("@ApplicationId",DbType.Guid);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_SaveCouponType Procedure
        /// </summary>
        public static StoredProcedure CskCouponsSaveCouponType(int? CouponTypeId, string Description, string ProcessingClassName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_SaveCouponType" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@CouponTypeId", CouponTypeId,DbType.Int32);
        	    
            sp.Command.AddParameter("@Description", Description,DbType.String);
        	    
            sp.Command.AddParameter("@ProcessingClassName", ProcessingClassName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_CheckSchemaVersion Procedure
        /// </summary>
        public static StoredProcedure AspnetCheckSchemaVersion(string Feature, string CompatibleSchemaVersion)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_CheckSchemaVersion" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@Feature", Feature,DbType.String);
        	    
            sp.Command.AddParameter("@CompatibleSchemaVersion", CompatibleSchemaVersion,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_AddProduct Procedure
        /// </summary>
        public static StoredProcedure CskPromoAddProduct(int? promoID, int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_AddProduct" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@promoID", promoID,DbType.Int32);
        	    
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_ChangePasswordQuestionAndAnswer Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipChangePasswordQuestionAndAnswer(string ApplicationName, string UserName, string NewPasswordQuestion, string NewPasswordAnswer)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_ChangePasswordQuestionAndAnswer" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@NewPasswordQuestion", NewPasswordQuestion,DbType.String);
        	    
            sp.Command.AddParameter("@NewPasswordAnswer", NewPasswordAnswer,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the INSERT_AddOrderEntryItem Procedure
        /// </summary>
        public static StoredProcedure InsertAddOrderEntryItem(int? orderID, int? productID, string sku, string name, decimal? pricePaid, decimal? retailPrice, int? quantity)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("INSERT_AddOrderEntryItem" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@orderID", orderID,DbType.Int32);
        	    
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            sp.Command.AddParameter("@sku", sku,DbType.String);
        	    
            sp.Command.AddParameter("@name", name,DbType.String);
        	    
            sp.Command.AddParameter("@pricePaid", pricePaid,DbType.Currency);
        	    
            sp.Command.AddParameter("@retailPrice", retailPrice,DbType.Currency);
        	    
            sp.Command.AddParameter("@quantity", quantity,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_AddProduct Procedure
        /// </summary>
        public static StoredProcedure CskPromoBundleAddProduct(int? bundleID, int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_AddProduct" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@bundleID", bundleID,DbType.Int32);
        	    
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_CreateUser Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipCreateUser(string ApplicationName, string UserName, string Password, string PasswordSalt, string Email, string PasswordQuestion, string PasswordAnswer, bool? IsApproved, DateTime? CurrentTimeUtc, DateTime? CreateDate, int? UniqueEmail, int? PasswordFormat, Guid? UserId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_CreateUser" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@Password", Password,DbType.String);
        	    
            sp.Command.AddParameter("@PasswordSalt", PasswordSalt,DbType.String);
        	    
            sp.Command.AddParameter("@Email", Email,DbType.String);
        	    
            sp.Command.AddParameter("@PasswordQuestion", PasswordQuestion,DbType.String);
        	    
            sp.Command.AddParameter("@PasswordAnswer", PasswordAnswer,DbType.String);
        	    
            sp.Command.AddParameter("@IsApproved", IsApproved,DbType.Boolean);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@CreateDate", CreateDate,DbType.DateTime);
        	    
            sp.Command.AddParameter("@UniqueEmail", UniqueEmail,DbType.Int32);
        	    
            sp.Command.AddParameter("@PasswordFormat", PasswordFormat,DbType.Int32);
        	    
            sp.Command.AddOutputParameter("@UserId",DbType.Guid);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_GetTaxRateByState Procedure
        /// </summary>
        public static StoredProcedure CskTaxGetTaxRateByState(string state)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_GetTaxRateByState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@state", state,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_GetAvailableProducts Procedure
        /// </summary>
        public static StoredProcedure CskPromoBundleGetAvailableProducts(int? bundleID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_GetAvailableProducts" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@bundleID", bundleID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_FindUsersByEmail Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipFindUsersByEmail(string ApplicationName, string EmailToMatch, int? PageIndex, int? PageSize)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_FindUsersByEmail" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@EmailToMatch", EmailToMatch,DbType.String);
        	    
            sp.Command.AddParameter("@PageIndex", PageIndex,DbType.Int32);
        	    
            sp.Command.AddParameter("@PageSize", PageSize,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_GetByProductID Procedure
        /// </summary>
        public static StoredProcedure CskPromoBundleGetByProductID(int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_GetByProductID" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_FindUsersByName Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipFindUsersByName(string ApplicationName, string UserNameToMatch, int? PageIndex, int? PageSize)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_FindUsersByName" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserNameToMatch", UserNameToMatch,DbType.String);
        	    
            sp.Command.AddParameter("@PageIndex", PageIndex,DbType.Int32);
        	    
            sp.Command.AddParameter("@PageSize", PageSize,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_GetSelectedProducts Procedure
        /// </summary>
        public static StoredProcedure CskPromoBundleGetSelectedProducts(int? bundleID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_GetSelectedProducts" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@bundleID", bundleID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetAllUsers Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetAllUsers(string ApplicationName, int? PageIndex, int? PageSize)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetAllUsers" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@PageIndex", PageIndex,DbType.Int32);
        	    
            sp.Command.AddParameter("@PageSize", PageSize,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_EnsureOrderCoupon Procedure
        /// </summary>
        public static StoredProcedure CskPromoEnsureOrderCoupon(int? orderID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_EnsureOrderCoupon" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@orderID", orderID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetNumberOfUsersOnline Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetNumberOfUsersOnline(string ApplicationName, int? MinutesSinceLastInActive, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetNumberOfUsersOnline" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@MinutesSinceLastInActive", MinutesSinceLastInActive,DbType.Int32);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_GetProductList Procedure
        /// </summary>
        public static StoredProcedure CskPromoGetProductList(int? promoID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_GetProductList" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@promoID", promoID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetPassword Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetPassword(string ApplicationName, string UserName, int? MaxInvalidPasswordAttempts, int? PasswordAttemptWindow, DateTime? CurrentTimeUtc, string PasswordAnswer)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetPassword" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@MaxInvalidPasswordAttempts", MaxInvalidPasswordAttempts,DbType.Int32);
        	    
            sp.Command.AddParameter("@PasswordAttemptWindow", PasswordAttemptWindow,DbType.Int32);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@PasswordAnswer", PasswordAnswer,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_ProductMatrix Procedure
        /// </summary>
        public static StoredProcedure CskPromoProductMatrix()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_ProductMatrix" , DataService.GetInstance("XsltExt"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetPasswordWithFormat Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetPasswordWithFormat(string ApplicationName, string UserName, bool? UpdateLastLoginActivityDate, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetPasswordWithFormat" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@UpdateLastLoginActivityDate", UpdateLastLoginActivityDate,DbType.Boolean);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_RemoveProducts Procedure
        /// </summary>
        public static StoredProcedure CskPromoRemoveProducts(int? promoID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_RemoveProducts" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@promoID", promoID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetUserByEmail Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetUserByEmail(string ApplicationName, string Email)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetUserByEmail" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@Email", Email,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Shipping_GetRates Procedure
        /// </summary>
        public static StoredProcedure CskShippingGetRates(decimal? weight)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Shipping_GetRates" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@weight", weight,DbType.Currency);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetUserByName Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetUserByName(string ApplicationName, string UserName, DateTime? CurrentTimeUtc, bool? UpdateLastActivity)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetUserByName" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@UpdateLastActivity", UpdateLastActivity,DbType.Boolean);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Shipping_GetRates_Air Procedure
        /// </summary>
        public static StoredProcedure CskShippingGetRatesAir(decimal? weight)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Shipping_GetRates_Air" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@weight", weight,DbType.Currency);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_GetUserByUserId Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipGetUserByUserId(Guid? UserId, DateTime? CurrentTimeUtc, bool? UpdateLastActivity)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_GetUserByUserId" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@UserId", UserId,DbType.Guid);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@UpdateLastActivity", UpdateLastActivity,DbType.Boolean);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Shipping_GetRates_Ground Procedure
        /// </summary>
        public static StoredProcedure CskShippingGetRatesGround(decimal? weight)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Shipping_GetRates_Ground" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@weight", weight,DbType.Currency);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_ResetPassword Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipResetPassword(string ApplicationName, string UserName, string NewPassword, int? MaxInvalidPasswordAttempts, int? PasswordAttemptWindow, string PasswordSalt, DateTime? CurrentTimeUtc, int? PasswordFormat, string PasswordAnswer)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_ResetPassword" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@NewPassword", NewPassword,DbType.String);
        	    
            sp.Command.AddParameter("@MaxInvalidPasswordAttempts", MaxInvalidPasswordAttempts,DbType.Int32);
        	    
            sp.Command.AddParameter("@PasswordAttemptWindow", PasswordAttemptWindow,DbType.Int32);
        	    
            sp.Command.AddParameter("@PasswordSalt", PasswordSalt,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@PasswordFormat", PasswordFormat,DbType.Int32);
        	    
            sp.Command.AddParameter("@PasswordAnswer", PasswordAnswer,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_FavoriteCategories Procedure
        /// </summary>
        public static StoredProcedure CskStatsFavoriteCategories(string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_FavoriteCategories" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_SetPassword Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipSetPassword(string ApplicationName, string UserName, string NewPassword, string PasswordSalt, DateTime? CurrentTimeUtc, int? PasswordFormat)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_SetPassword" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@NewPassword", NewPassword,DbType.String);
        	    
            sp.Command.AddParameter("@PasswordSalt", PasswordSalt,DbType.String);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@PasswordFormat", PasswordFormat,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_FavoriteProducts Procedure
        /// </summary>
        public static StoredProcedure CskStatsFavoriteProducts(string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_FavoriteProducts" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_UnlockUser Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipUnlockUser(string ApplicationName, string UserName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_UnlockUser" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_Tracker_GetByBehaviorID Procedure
        /// </summary>
        public static StoredProcedure CskStatsTrackerGetByBehaviorID(int? behaviorID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_Tracker_GetByBehaviorID" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@behaviorID", behaviorID,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_UpdateUser Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipUpdateUser(string ApplicationName, string UserName, string Email, string Comment, bool? IsApproved, DateTime? LastLoginDate, DateTime? LastActivityDate, int? UniqueEmail, DateTime? CurrentTimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_UpdateUser" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@Email", Email,DbType.String);
        	    
            sp.Command.AddParameter("@Comment", Comment,DbType.String);
        	    
            sp.Command.AddParameter("@IsApproved", IsApproved,DbType.Boolean);
        	    
            sp.Command.AddParameter("@LastLoginDate", LastLoginDate,DbType.DateTime);
        	    
            sp.Command.AddParameter("@LastActivityDate", LastActivityDate,DbType.DateTime);
        	    
            sp.Command.AddParameter("@UniqueEmail", UniqueEmail,DbType.Int32);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_Tracker_GetByProductAndBehavior Procedure
        /// </summary>
        public static StoredProcedure CskStatsTrackerGetByProductAndBehavior(int? behaviorID, string sku)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_Tracker_GetByProductAndBehavior" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@behaviorID", behaviorID,DbType.Int32);
        	    
            sp.Command.AddParameter("@sku", sku,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_UpdateUserInfo Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipUpdateUserInfo(string ApplicationName, string UserName, bool? IsPasswordCorrect, bool? UpdateLastLoginActivityDate, int? MaxInvalidPasswordAttempts, int? PasswordAttemptWindow, DateTime? CurrentTimeUtc, DateTime? LastLoginDate, DateTime? LastActivityDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_UpdateUserInfo" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@IsPasswordCorrect", IsPasswordCorrect,DbType.Boolean);
        	    
            sp.Command.AddParameter("@UpdateLastLoginActivityDate", UpdateLastLoginActivityDate,DbType.Boolean);
        	    
            sp.Command.AddParameter("@MaxInvalidPasswordAttempts", MaxInvalidPasswordAttempts,DbType.Int32);
        	    
            sp.Command.AddParameter("@PasswordAttemptWindow", PasswordAttemptWindow,DbType.Int32);
        	    
            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc,DbType.DateTime);
        	    
            sp.Command.AddParameter("@LastLoginDate", LastLoginDate,DbType.DateTime);
        	    
            sp.Command.AddParameter("@LastActivityDate", LastActivityDate,DbType.DateTime);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_Tracker_SynchTrackingCookie Procedure
        /// </summary>
        public static StoredProcedure CskStatsTrackerSynchTrackingCookie(string userName, string trackerCookie)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_Tracker_SynchTrackingCookie" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            sp.Command.AddParameter("@trackerCookie", trackerCookie,DbType.String);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_Paths_CreatePath Procedure
        /// </summary>
        public static StoredProcedure AspnetPathsCreatePath(Guid? ApplicationId, string Path, Guid? PathId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Paths_CreatePath" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@ApplicationId", ApplicationId,DbType.Guid);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddOutputParameter("@PathId",DbType.Guid);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_AddItemToCart Procedure
        /// </summary>
        public static StoredProcedure CskStoreAddItemToCart(string userName, int? productID, string attributes, decimal? pricePaid, string promoCode, int? quantity)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_AddItemToCart" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	    
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	    
            sp.Command.AddParameter("@attributes", attributes,DbType.String);
        	    
            sp.Command.AddParameter("@pricePaid", pricePaid,DbType.Currency);
        	    
            sp.Command.AddParameter("@promoCode", promoCode,DbType.String);
        	    
            sp.Command.AddParameter("@quantity", quantity,DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAdministration_DeleteAllState Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAdministrationDeleteAllState(bool? AllUsersScope, string ApplicationName, int? Count)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAdministration_DeleteAllState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@AllUsersScope", AllUsersScope,DbType.Boolean);
        	    
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddOutputParameter("@Count",DbType.Int32);
        	    
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_CategoryGetActive Procedure
        /// </summary>
        public static StoredProcedure CskStoreCategoryGetActive()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_CategoryGetActive" , DataService.GetInstance("XsltExt"));
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the aspnet_PersonalizationAdministration_FindState Procedure
        /// </summary>
        public static StoredProcedure AspnetPersonalizationAdministrationFindState(bool? AllUsersScope, string ApplicationName, int? PageIndex, int? PageSize, string Path, string UserName, DateTime? InactiveSinceDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_PersonalizationAdministration_FindState" , DataService.GetInstance("XsltExt"));
        	
            sp.Command.AddParameter("@AllUsersScope", AllUsersScope,DbType.Boolean);
        	    
            sp.Command.AddParameter("@ApplicationName", ApplicationName,DbType.String);
        	    
            sp.Command.AddParameter("@PageIndex", PageIndex,DbType.Int32);
        	    
            sp.Command.AddParameter("@PageSize", PageSize,DbType.Int32);
        	    
            sp.Command.AddParameter("@Path", Path,DbType.String);
        	    
            sp.Command.AddParameter("@UserName", UserName,DbType.String);
        	    
            sp.Command.AddParameter("@InactiveSinceDate", InactiveSinceDate,DbType.DateTime);
        	    
            return sp;
        }

        
    }

    
}

